﻿USE [NWBA]
GO

INSERT INTO [dbo].[Customer]
           ([CustomerName]
           ,[TFN]
           ,[Address]
           ,[City]
           ,[State]
           ,[PostCode]
           ,[Phone])
     VALUES
           ('Matthew Bolger'
           ,'123456789'
           ,'123 Fake Street'
           ,'Melbourne'
           ,'VIC'
           ,'3000'
           ,'(61)- 1234 5678')
GO

INSERT INTO [dbo].[Customer]
           ([CustomerName]
           ,[TFN]
           ,[Address]
           ,[City]
           ,[State]
           ,[PostCode]
           ,[Phone])
     VALUES
           ('Shekhar'
           ,'987654321'
           ,'123 Fake Street'
           ,'Melbourne'
           ,'VIC'
           ,'3000'
           ,'(61)- 5678 1234')
GO

INSERT INTO [dbo].[Customer]
           ([CustomerName]
           ,[TFN]
           ,[Address]
           ,[City]
           ,[State]
           ,[PostCode]
           ,[Phone])
     VALUES
           ('Aido'
           ,NULL
           ,NULL
           ,NULL
           ,NULL
           ,NULL
           ,'(61)- 1234 1234')
GO

INSERT INTO [dbo].[Payee]
           ([PayeeName]
           ,[Address]
           ,[City]
           ,[State]
           ,[PostCode]
           ,[Phone])
     VALUES
           ('Bolger Electrics'
           ,'Building 14 Level 9'
           ,'Melbourne'
           ,'VIC'
           ,'3000'
           ,'(61)- 1111 1111');
GO

INSERT INTO [dbo].[Payee]
           ([PayeeName]
           ,[Address]
           ,[City]
           ,[State]
           ,[PostCode]
           ,[Phone])
     VALUES
           ('Bolger Internets'
           ,'Building 14 Level 10'
           ,'Melbourne'
           ,'VIC'
           ,'3000'
           ,'(61)- 2222 2222');
GO

INSERT INTO [dbo].[Payee]
           ([PayeeName]
           ,[Address]
           ,[City]
           ,[State]
           ,[PostCode]
           ,[Phone])
     VALUES
           ('Bolger Waters'
           ,'Building 80'
           ,'Melbourne'
           ,'VIC'
           ,'3000'
           ,'(61)- 3333 3333');
GO

INSERT INTO [dbo].[Payee]
           ([PayeeName]
           ,[Address]
           ,[City]
           ,[State]
           ,[PostCode]
           ,[Phone])
     VALUES
           ('Luke Rates'
           ,NULL
           ,NULL
           ,NULL
           ,NULL
           ,'(61)- 4444 4444');
GO

INSERT INTO [dbo].[Login]
           ([CustomerID]
           ,[UserID]
           ,[Password]
           ,[ModifyDate])
     VALUES
           (1
           ,'mbolger'
           ,'abc123'
           ,SYSDATETIME())
GO

INSERT INTO [dbo].[Login]
           ([CustomerID]
           ,[UserID]
           ,[Password]
           ,[ModifyDate])
     VALUES
           (2
           ,'shekhar'
           ,'def456'
           ,SYSDATETIME())
GO

INSERT INTO [dbo].[Login]
           ([CustomerID]
           ,[UserID]
           ,[Password]
           ,[ModifyDate])
     VALUES
           (3
           ,'aluke'
           ,'password'
           ,SYSDATETIME())
GO
